Bank Personal Loan Analysis

Data description

Visualize distribution of the data

array([[<matplotlib.axes._subplots.AxesSubplot object at 0x7fe3966dc1d0>,
        <matplotlib.axes._subplots.AxesSubplot object at 0x7fe394abbf90>,
        <matplotlib.axes._subplots.AxesSubplot object at 0x7fe394b32c50>],
       [<matplotlib.axes._subplots.AxesSubplot object at 0x7fe394f58fd0>,
        <matplotlib.axes._subplots.AxesSubplot object at 0x7fe394f8dc90>,
        <matplotlib.axes._subplots.AxesSubplot object at 0x7fe3966824d0>],
       [<matplotlib.axes._subplots.AxesSubplot object at 0x7fe394d70cd0>,
        <matplotlib.axes._subplots.AxesSubplot object at 0x7fe394ca6510>,
        <matplotlib.axes._subplots.AxesSubplot object at 0x7fe394cb2090>],
       [<matplotlib.axes._subplots.AxesSubplot object at 0x7fe394c30a10>,
        <matplotlib.axes._subplots.AxesSubplot object at 0x7fe3934d6d50>,
        <matplotlib.axes._subplots.AxesSubplot object at 0x7fe393784590>]],
      dtype=object)
<matplotlib.axes._subplots.AxesSubplot at 0x7fe396707990>
<matplotlib.axes._subplots.AxesSubplot at 0x7fe37718ec90>
There are 624 records which has negative values for experience, appox1.04 %

Correlation of data

<matplotlib.axes._subplots.AxesSubplot at 0x7fe393645e50>

Analyze Education Status of customer

Explore the account holder distribution

Age Income Family CCAvg Education Mortgage Personal Loan Securities Account CD Account Online CreditCard Edu_mark Account_holder_category
0 25 49 4 1.6 1 0 0 1 0 0 0 Undergrad Holds only securities
1 45 34 3 1.5 1 0 0 1 0 0 0 Undergrad Holds only securities
2 39 11 1 1.0 1 0 0 0 0 0 0 Undergrad Does not Holds securities or Deposit
3 35 100 1 2.7 2 0 0 0 0 0 0 Graduate Does not Holds securities or Deposit
4 35 45 4 1.0 2 0 0 0 0 0 1 Graduate Does not Holds securities or Deposit
Does not Holds securities or Deposit    4323
Holds only securities                    375
Holds only Deposit                       155
Holds securities & Deposit               147
Name: Account_holder_category, dtype: int64

Analyze customer on the basis of their education status, income and personal loan status

<matplotlib.axes._subplots.AxesSubplot at 0x7fe3939b6690>
<matplotlib.legend.Legend at 0x7fe377933290>

Analyze categories of customers on the basis of Security account, Online, Account_holder category & credit card

How age of a person is going to be a factor in available loan?

<matplotlib.axes._subplots.AxesSubplot at 0x7fe378cc8cd0>
Age does not have impact on availing personal loan as the p_value is greater than 0.05 with a value of 0.584959263705325

Does income of a person have an impact on availing loan?

Income does have impact on availing personal loan, as the p_value is less than 0.05 with a value of 0.0

Does the family size makes them to avail loan?

Family does have impact on availing personal loan, as the p_value is less than 0.05 with a value of 1.4099040685673807e-05
[NbConvertApp] Converting notebook Finance_to_html.ipynb to html
[NbConvertApp] Writing 4623587 bytes to Finance_to_html.html